from common.connect_db import MyDB

my_db = MyDB()


class DataBaseEstate:

	@staticmethod
	def get_display_video_ids():
		"""
		查所有通过视频的id
		"""
		sql = "select id from estate_video_zone where `status`=20"
		result = my_db.execute_select('estate', sql)
		return result


if __name__ == '__main__':
	id_list = DataBaseEstate.get_display_video_ids()
	ids = list()
	for i in id_list:
		ids.append(i[0])
	print(ids)

